﻿CREATE TABLE [dbo].[ExternalEntities] (
    [EntityID]      NVARCHAR (100) NOT NULL,
    [EntityType]    NVARCHAR (100) NOT NULL,
    [EntitySubType] NVARCHAR (100) NULL,
    [EntityName]    NVARCHAR (255) NULL,
    [LookupName]    NVARCHAR (MAX) NULL,
    CONSTRAINT [PK_ExternalEntities] PRIMARY KEY CLUSTERED ([EntityID] ASC)
);

